package main.java.tmi.actualStockStatus.service.impl;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import main.java.tmi.actualStockStatus.service.ActualStockStatusVO;
import main.java.tmi.common.service.impl.AbstractDao;

import org.springframework.stereotype.Repository;

/**
 * ActualStockStatus Data Access Object
 *
 * @author min™
 * @since 2012. 05. 08.
 */
@Repository
public class ActualStockStatusDAO extends AbstractDao {
	
	/**
	 * ActualStockStatus search
	 * @return List<ActualStockStatusVO>
	 * @throws SQLException 
	 */
	@SuppressWarnings("unchecked")
	public List<ActualStockStatusVO> getActualStockStatusView(Map<String,String> param) throws SQLException {
				
		return (List<ActualStockStatusVO>) list("ActualStockStatusDAO.getActualStockStatusView", param);
	}
	
	/**
	 * ActualStockStatus search
	 * @return List<ActualStockStatusVO>
	 * @throws SQLException 
	 */
	@SuppressWarnings("unchecked")
	public int getActualStockStatusViewCount(Map<String,String> param) throws SQLException {
		return Integer.parseInt((String) getSqlMapClientTemplate().queryForObject("ActualStockStatusDAO.getActualStockStatusViewCount", param));
	}
}
